Percona Server for MongoDB 3.2.0-1.0 - Range queries performance
Setup
- Client and server on the same machine
- Client sofwware is sysbench (https://github.com/Percona-Lab/sysbench/tree/dev-mongodb-support).
- CPU: 48 logical CPU threads (Intel® Xeon® CPU E5-2680 v3 @ 2.50GHz).
- Memory: 120GB or 20GB (the latter limited via cgroup).
- Disk: hdd (HGST HUH728080ALE600), slowssd (Crucial CT960M500SSD1), fastssd (Intel 3600 nvme)
- sysbench with mongodb support, 16 collections x 10M or 60M documents (~35GB or ~200G uncompressed), uniform and pareto distributions.
- Workloads are labeled as:
- cpubound (10M documents per collection, fastssd storage)
- iobound (60M documents per collection, fastssd and slowssd storage, 120GB RAM)
- iobound_heavy (same as previous, but with 20GB RAM)
Throughput per threads and workload






Throughput per threads and workload, summary per engine
## Error: Faceting variables must have at least one value
## The following objects are masked from data_wt_10000:
##
## disk, distribution, engine, range_size, reads, response_time,
## size, threads, tps, ts, user_provided_threads, workload,
## writes
##
## The following objects are masked from data_wt_10000:
##
## disk, distribution, engine, range_size, reads, response_time,
## size, threads, tps, ts, user_provided_threads, workload,
## writes

## The following objects are masked from data_wt_10000:
##
## disk, distribution, engine, range_size, reads, response_time,
## size, threads, tps, ts, user_provided_threads, workload,
## writes

## The following objects are masked from data_wt_10000:
##
## disk, distribution, engine, range_size, reads, response_time,
## size, threads, tps, ts, user_provided_threads, workload,
## writes

## The following objects are masked from data_wt_10000:
##
## disk, distribution, engine, range_size, reads, response_time,
## size, threads, tps, ts, user_provided_threads, workload,
## writes

## The following objects are masked from data_wt_10000:
##
## disk, distribution, engine, range_size, reads, response_time,
## size, threads, tps, ts, user_provided_threads, workload,
## writes


Throughput per threads and workload, details.
Throughput per threads and workload, WiredTiger
## Error: Faceting variables must have at least one value

Throughput per threads and workload, RocksDB






